﻿/*
 * Indicates whether a specified string is null, empty, or consists only of white-space characters.
 */
create function [String].[IsNullOrWhiteSpace] ( @p_String nvarchar(max) )
returns bit as
begin

  if @p_String is null or String.Trim( @p_String ) = ''
  begin
    return 1;
  end
  
  return 0;

end